﻿CREATE TABLE [acms].[Email] (
    [Id]           INT            IDENTITY (1, 1) NOT NULL,
    [UserId]       INT            NULL,
    [EmailAddress] VARCHAR (255)  NULL,
    [Name]         VARCHAR (100)  NULL,
    [FilePath]     VARCHAR (200)  NOT NULL,
    [To]           VARCHAR (200)  NULL,
    [Cc]           VARCHAR (200)  NULL,
    [Bcc]          VARCHAR (200)  NULL,
    [From]         VARCHAR (200)  NULL,
    [ReplyTo]      VARCHAR (200)  NULL,
    [Subject]      VARCHAR (200)  NULL,
    [Body]         VARCHAR (2000) NULL,
    [Html]         BIT            NULL,
    [Created]      DATETIME       NOT NULL,
    [Sent]         DATETIME       NULL,
    [Failed]       BIT            NOT NULL,
    [ConcurencyId] TIMESTAMP      NOT NULL
);

